package de.kalinasch.pa.placereminder.database;

public interface I_Incident {
	/** Database settings */
	public final String TABLE_NAME = "incident";
	public final int DB_VERSION = 1;
	
	/** Column names */
	public final String ID = "id";
	public final String TITLE = "title";
	public final String DESCRIPTION = "description";
	public final String STREET = "street";
	public final String TOWN = "town";
	public final String RADIUS = "radius";
	public final String LONGITUDE = "longitude";
	public final String LATITUDE = "latitude";

	/** Statement to create database schema */
	public final String SQL_CREATE = "CREATE TABLE " + TABLE_NAME +  " ("
		+ ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
		+ TITLE + " TEXT NOT NULL, "
		+ DESCRIPTION + " TEXT NOT NULL, "
		+ STREET + " TEXT NOT NULL, "
		+ TOWN + " TEXT NOT NULL, "
		+ RADIUS + " INTEGER NOT NULL, "
		+ LONGITUDE + " REAL NOT NULL, "
		+ LATITUDE + " REAL NOT NULL"
		+ ");";
	
	/** Statement to rebuild database schema */
	public final String SQL_AFTER_ALTER = "DROP TABLE IF EXISTS " + TABLE_NAME;
}
